Clears AutoFilter criteria when set to True. Adding criteria sets this property to False. If there are no criteria and this property is set to False, no data will be shown. Read/write Boolean.
expression.ShowAll
expression Required. An expression that returns a Criteria object.
This example clears the AutoFilter criteria for column 1 on the active worksheet and reapplies the AutoFilter to the worksheet.
Sub ReapplyAutoFilter()
Dim afAutoFilter
' Set a variable to the current filter settings.
Set afAutoFilter = Spreadsheet1.ActiveSheet.AutoFilter
' Show all records.
afAutoFilter.Filters(1).Criteria.ShowAll = True
' Reapply the filters.
afAutoFilter.Apply
End Sub